package com.sinosoft.perfect.system._unit;

import java.sql.SQLException;
import java.util.List;

import com.sinosoft.perfect.system._.po.TUnit;
import com.sinosoft.perfect.system._.po.TUnitInformation;
import com.sinosoft.perfect.system._.po.TUserRegisterNum;
import com.sinosoft.perfect.system._unit.formBean.UnitForm;

public interface MapperSystemUnit {

	public List<UnitForm> selectTUnit(TUnit tunit) throws SQLException;

	public List<TUnit> selectTUnitAndChildrenByUnitId(String unitId) throws SQLException;

	public Long selectTUnitSortNum(TUnit tunit) throws SQLException;

	public Object selectTUnitMAXSortNum(TUnit tunit) throws SQLException;

	public Object selectTUnitByName(TUnit tunit) throws SQLException;

	public List<TUnitInformation> selectTUnitInfo(TUnitInformation tunitinformation) throws SQLException;

	public List<TUserRegisterNum> selectTUserRegisterNum(TUserRegisterNum tuserregisternum) throws SQLException;

	public List<TUserRegisterNum> selectTUserRegisterNumByNum(TUserRegisterNum tuserregisternum) throws SQLException;

	public Object insertTUnit(TUnit tunit) throws SQLException;

	public Object insertTUnitInformation(TUnitInformation tunitinformation) throws SQLException;

	public Object insertTUserRegisterNum(TUserRegisterNum tuserregisternum) throws SQLException;

	public int updateTUnit(TUnit tunit) throws SQLException;

	public int updateTUnitAndChildrenStatus(TUnit tunit) throws SQLException;

	public int updateTUnitInfoByPK(TUnitInformation tunitinformation) throws SQLException;

	public int updateTUserRegisterNumByPK(TUserRegisterNum tuserregisternum) throws SQLException;

	public int updateTUserRegisterNumTimesByUnitId(String unitId) throws SQLException;

	public int deleteTUnitByUnitId(String unitId) throws SQLException;

	public int deleteTUserUnitRelationByUnitId(String unitId) throws SQLException;

	public int deleteTUnitInfoByUnitId(String unitId) throws SQLException;

	public int deleteTUserRegisterNumByUnitId(String unitId) throws SQLException;

	public List<TUnit> selectTUnitByUnitIds(String unitIds) throws SQLException ;
}
